123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 |
- -- UAP报表脚本(数量: 1张 生成时间:2019年8月23日 16:31)
- -- 1.单据对照表( 1个视图,项目号U8CUSTDEF)
- -- "单据对照表"
- -- 添加新的UAP报表
- -- 插入项目信息
- DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF'
- INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/8/21 18:57:15',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
- GO
- -- UAP报表数据报表级基础信息
- DELETE FROM UAP_Report WHERE ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9'
- INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'Function1',N'',N'U8CUSTDEF',N'SA',N'',N'',N'1',N'0',N'demo',N'2019/8/23 16:19:55',N'0',NULL,NULL,NULL,N'1',N'SARPT232635',NULL,N'1',NULL,N'1',NULL)
- GO
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'en-US'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'en-US',N'单据对照表',NULL,N'0')
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-CN'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-CN',N'单据对照表',NULL,N'0')
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-TW'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-TW',N'单据对照表',NULL,N'0')
- GO
- DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9'
- INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'f45802d3-ef66-42f6-965c-266d4756396e')
- GO
- -- UAP报表数据源:可能包含进行扩展后的BO对象
- DELETE FROM BD_BusinessObjects WHERE MetaID=N'b0465d91-8178-40df-812d-c3d79a66aa1e'
- INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'vouchermaps(2019-08-23 下午 16:31:37)',N'U8CUSTDEF',N'SA',N'<BusinessObject name="vouchermaps" description="单据对照表" descriptionCN="单据对照表" descriptionTW="" descriptionUS="" entityID="">
- <Function type="Query" name="Function1" description="" descriptionCN="" descriptionTW="" descriptionUS="">
- <DataQueries><Query name="Query1" querist="SQLQuerist" description="" descriptionCN="" descriptionTW="" descriptionUS="">
- <Distinct value="False"/><ResultTable name="ResultTable1" description="" descriptionCN="" descriptionTW="" descriptionUS="" >
- <Column name="vouchertype" dataType="String" description="单据类型" descriptionCN="单据类型" descriptionTW="" descriptionUS=""/>
- <Column name="ccode" dataType="String" description="原始单号" descriptionCN="原始单号" descriptionTW="" descriptionUS=""/>
- <Column name="newcode" dataType="String" description="新单号" descriptionCN="新单号" descriptionTW="" descriptionUS=""/>
- <Column name="ddate" dataType="DateTime" description="单据日期" descriptionCN="单据日期" descriptionTW="" descriptionUS=""/>
- <Column name="importdate" dataType="DateTime" description="导入日期" descriptionCN="导入日期" descriptionTW="" descriptionUS=""/>
- <Column name="processdate" dataType="DateTime" description="处理日期" descriptionCN="处理日期" descriptionTW="" descriptionUS=""/>
- <Column name="transtype" dataType="String" description="处理方向" descriptionCN="处理方向" descriptionTW="" descriptionUS=""/>
- </ResultTable><Content type="Script" ToolType="Manual"><Select>Select * from wtu..v_datamaps</Select>
- <Where></Where>
- <OrderBy></OrderBy>
- <GroupBy></GroupBy>
- <Having></Having>
- <From></From>
- </Content>
- </Query></DataQueries></Function></BusinessObject>',N'单据对照表',N'ReportBO',N'',N'0')
- GO
- -- UAP报表过滤条件
- DELETE FROM flt_DefineMeta_Cust WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
- DELETE FROM flt_DefineMeta_Cache WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
- DELETE FROM flt_DefineMeta_Base WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
- INSERT INTO flt_DefineMeta_Base(FilterID,ProjectNO,XMLExpression,SubNO,FilterName,FilterDesc,IsUpgrade,bLocked,cLockedBy,PersonItems)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'U8CUSTDEF',N'<root canceladvanceitemlist="" title="" behaviorclass="" hasgroupby="0"><filter><items><item projectno="U8CUSTDEF" position="10" name="importdate" reftype="2" refid="" commonlogic="uq" pointbit="-1" fieldname="importdate" fieldclass="" iscommon="1" mustinput="1" rangeinput="1" multselect="0" allowupdatecomparelogic="1" orlogic="0" showstyle="0" ispara="0" displayinportalview="0" autodisplaytext="0" isfacilitycondition="0" isjoinfulltextquery="0" format=""/></items></filter></root>
- ',N'SA',NULL,NULL,N'0',NULL,NULL,NULL)
- GO
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'en-us'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'en-us',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-cn'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-cn',N'<root><items><item caption="导入日期" columncaption="" enum="" name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-tw'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-tw',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- GO
- -- UAP报表添加新的视图
- -- UAP报表视图级基础信息
- DELETE FROM UAP_ReportView WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e'
- INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'1',NULL,N'0',NULL,N'20,20,20,20',N'6',N'0',NULL,NULL,N'40',N'0',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
- GO
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'en-US',N'单据对照表',NULL)
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-CN',N'单据对照表',NULL)
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-TW',N'单据对照表',NULL)
- GO
- -- UAP报表视图的格式信息
- UPDATE UAP_ReportView SET ID=N'f45802d3-ef66-42f6-965c-266d4756396e',Format=NULL,RuntimeFormat=N'<RuntimeFormat Id=""><RuntimeFormatGroupFormat Id="00000000-0000-0000-0000-000000000001"><RuntimeFormatGroupStyle IsFoldRow="False" Id="Plane.WithDetail"><RuntimeFormatGroupLevel Id="1"><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="0" IsMerge="False" Id="vouchertype" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="1" IsMerge="False" Id="ccode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="2" IsMerge="False" Id="newcode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="3" IsMerge="False" Id="ddate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="4" IsMerge="False" Id="importdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="5" IsMerge="False" Id="processdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="6" IsMerge="False" Id="transtype" /></RuntimeFormatGroupLevel></RuntimeFormatGroupStyle></RuntimeFormatGroupFormat></RuntimeFormat>',Chartstring=NULL WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e'
- GO
- UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'en-US',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US'
- UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-CN',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN'
- UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-TW',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW'
- GO
- -- 备份的原始视图格式
- -- 颜色字体方案
- -- 功能权限
- DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'f45802d3-ef66-42f6-965c-266d4756396e'
- INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'_f45802d3-ef66-42f6-965c-266d4756396e',N'1')
- GO
- -- 视图的字段权限
- -- 门户菜单相关
- -- 联查功能
- -- 报表自定义事件
|